/**
 * Created with IntelliJ IDEA.
 * Description:
 * User: WHY
 * Date: 2023-02-24
 * Time: 23:17
 */
public class TestDemo {
    public static void main(String[] args) {
        Enter password: ****
        Welcome to the MySQL monitor.  Commands end with ; or \g.
                Your MySQL connection id is 2
        Server version: 5.7.8-rc-log MySQL Community Server (GPL)

        Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

                Oracle is a registered trademark of Oracle Corporation and/or its
        affiliates. Other names may be trademarks of their respective
        owners.

                Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

        mysql> show databases;
        +--------------------+
                | Database           |
                +--------------------+
                | information_schema |
| java105            |
| java107            |
| java108            |
| mysql              |
| performance_schema |
| sys                |
                +--------------------+
                        7 rows in set (0.03 sec)

        mysql> use java108;
        Database changed
        mysql> show tables;
        +-------------------+
                | Tables_in_java108 |
                +-------------------+
                | goods             |
| library           |
| teacher           |
                +-------------------+
                        3 rows in set (0.00 sec)

        mysql> update library set price=61 where name='java核心技术';
        Query OK, 1 row affected (0.09 sec)
        Rows matched: 1  Changed: 1  Warnings: 0

        mysql> select* from teacher;
        +--------+------+--------+--------+--------+-----------+----------+------+
                | name   | age  | height | weight | gender | education | birthday | id   |
                +--------+------+--------+--------+--------+-----------+----------+------+
                | 张三   | NULL |   NULL |   NULL | NULL   | NULL      | NULL     |    2 |
                +--------+------+--------+--------+--------+-----------+----------+------+
                        1 row in set (0.01 sec)

        mysql> show java107;
        ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'java107' at line 1
        mysql> use java107;

    }
}
